set hive.exec.dynamic.partition=true;            --  动态分区
set hive.exec.dynamic.partition.mode=nonstrict;
set hive.exec.max.dynamic.partitions=90;         --  每天生成 60 个分区
set hive.exec.max.dynamic.partitions.pernode=90; --  每天生成 60 个分区

insert overwrite table jms_dim.dim_lmdm_sys_scanning_type
select
id
,name
,en_name
,cn_name
,abbreviation
,native_name
,country_id
,code
,is_enable
,is_delete
,create_by
,update_by
,create_by_name
,update_by_name
,create_time
,update_time
,version
,sort
from jms_ods.yl_lmdm_sys_scanning_type where dt= '{{ execution_date | cst_ds }}'
 distribute by 1 ;